package cn.edu.dao;

import cn.edu.domain.PieData;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author Davey chan
 */
@Mapper
public interface lead_InfomationDao {
//    教务处获取年度考核 优良合格的数量
        @Select("select count(*) from annual_examination where checkResult like '优'")
        int GetExcellent();
            @Select("select count(*) from annual_examination where checkResult like '良'" )
        int GetGood();
            @Select("select count(*) from annual_examination where checkResult like '合格'")
        int GetNormal();
//    教师工作部获得下面的数量
    //   获得论文的数量
    int GetthesisNum(@Param("academyName") String academyName, @Param("departmentName") String departmentName,@Param("year") String year);
    //    获得专利的数量
    int GetPatentNum(@Param("academyName") String academyName, @Param("departmentName") String departmentName,@Param("year") String year);
    //获得著作的数量
    int GetOpsNum(@Param("academyName") String academyName, @Param("departmentName") String departmentName,@Param("year") String year);
    //获得科研项目数的数量
    int Getresearch_projectNum(@Param("academyName") String academyName, @Param("departmentName") String departmentName,@Param("year") String year);
//    教授的数量
int GetprofessorNum(@Param("academyName") String academyName, @Param("departmentName") String departmentName);
//    副教授的数量
int GetAsprofessorNum(@Param("academyName") String academyName, @Param("departmentName") String departmentName);
//    讲师的数量
int GetLecturerNum(@Param("academyName") String academyName, @Param("departmentName") String departmentName);
//年度考核
//查询各个获奖的情况
List<PieData> GetAward(@Param("academyName") String academyName, @Param("departmentName") String departmentName,@Param("year") String year);
List<Integer> GetExamine(@Param("academyName") String academyName, @Param("departmentName") String departmentName);
}
